package dao;

import util.ConnMySQL;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;


public class travellerTeamDao {
    public void insetCity(String city,String id) throws Exception{
        Connection conn = ConnMySQL.getConnection();
        String sql = "update users set touristGroupId=? where idusers=?";
        PreparedStatement ps = null;
        ps = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
        ps.setString(1, city);
        ps.setString(2, id);
        ResultSet rs = ps.executeQuery();
    }
}
